0, In this animation, we will take a look at the Recordset object.
4, You use Recordset objects to manipulate data in a database at the record level.
11, There are five types of recordset objects available in data access objects: table type, dynaset type, snapshot type, forward only type and dynamic type.
23, A recordset object represents the records in a table or the records that result from running query.
30, You use the OpenRecordset method of the Database object to create a recordset object.
36, Here, we are creating a dynaset type recordset based on a SQL statement.
41, Once you have created the recordset you can add, delete, and edit records in the recordset.
49, To add new records to the recordset, you use the AddNew method of the recordset object.
55, The position of the new record depends on the type of recordset.
59, In a dynaset type of recordset, records are inserted at the end of the recordset, regardless of any sorting or ordering rules that were in effect when the recordset was opened.
70, After you modify the new record, you use the Update method of the Recordset object to save the changes and add the record to the recordset.
79, No changes will occur in the database until you use the Update method.
84, Remember, before you can delete a record from a recordset, the recordset must contain a current record.
91, If there are no current records in the recordset, a run-time error occurs.
97, In an updateable recordset object, the Delete method removes the current record and makes it inaccessible.
104, Although you can't edit or use the deleted record, it remains current.
108, Once you move on to another record you can't make the deleted record current again.
113, Any subsequent references to a deleted record in a recordset will be invalid and produce an error.
120, To make changes to an existing record, you use the Edit method of the Recordset object.
126, When you edit a record, the changes made to the current record's fields are copied into the copy buffer.
133, After you make the edits to the record, you use the Update method to save your changes.
139, Now let's take a look at moving within a Recordset object.
144, To move to a particular record within a recordset, you apply move methods.
149, For example, a MoveFirst method points to the very first record in the recordset.
155, Similarly, you can use the MoveLast method to move the last record in the recordset.
162, When you are moving through a recordset, it is important to stay within the recordset boundaries.
167, What happens when you try to move to the next record when you are already pointing at the last record?
173, In a situation like this, you need to check the end of file, or EOF, property of the recordset object.
181, When you try to move past the last record, the EOF property is set to true but no error is generated.
189, If you try another move next operation, a run-time trappable error is created.
194, You must trap this error using an appropriate error handler.
198, Similarly, you use the beginning of file or BOF property of the recordset to prevent moving past the beginning of the recordset.
